﻿<?xml version="1.0" encoding="utf-8"?>
<edmx:Edmx Version="3.0" xmlns:edmx="http://schemas.microsoft.com/ado/2009/11/edmx">
  <!-- EF Runtime content -->
  <edmx:Runtime>
    <!-- SSDL content -->
    <edmx:StorageModels>
    <Schema Namespace="DocFoldersDbModel.Store" Alias="Self" Provider="System.Data.SqlClient" ProviderManifestToken="2012" xmlns:store="http://schemas.microsoft.com/ado/2007/12/edm/EntityStoreSchemaGenerator" xmlns="http://schemas.microsoft.com/ado/2009/11/edm/ssdl">
  <EntityContainer Name="DocFoldersDbModelStoreContainer">
    <EntitySet Name="Folders" EntityType="DocFoldersDbModel.Store.Folders" store:Type="Tables" Schema="dbo" />
    <EntitySet Name="Docs" EntityType="DocFoldersDbModel.Store.Docs" store:Type="Tables" Schema="dbo" />
    <EntitySet Name="Comments" EntityType="DocFoldersDbModel.Store.Comments" store:Type="Tables" Schema="dbo" />
    <EntitySet Name="FolderDocs" EntityType="DocFoldersDbModel.Store.FolderDocs" store:Type="Tables" Schema="dbo" />
    <EntitySet Name="DocAttachments" EntityType="DocFoldersDbModel.Store.DocAttachments" store:Type="Tables" Schema="dbo" />
    <EntitySet Name="FolderSubFolders" EntityType="DocFoldersDbModel.Store.FolderSubFolders" store:Type="Tables" Schema="dbo" />
    <AssociationSet Name="FK_FolderDocs_Folder" Association="DocFoldersDbModel.Store.FK_FolderDocs_Folder">
      <End Role="Folder" EntitySet="Folders" />
      <End Role="FolderDocs" EntitySet="FolderDocs" />
    </AssociationSet>
    <AssociationSet Name="FK_FolderDocs_Doc" Association="DocFoldersDbModel.Store.FK_FolderDocs_Doc">
      <End Role="Doc" EntitySet="Docs" />
      <End Role="FolderDocs" EntitySet="FolderDocs" />
    </AssociationSet>
    <AssociationSet Name="DocComments" Association="DocFoldersDbModel.Store.DocComments">
      <End Role="Doc" EntitySet="Docs" />
      <End Role="Comment" EntitySet="Comments" />
    </AssociationSet>
    <AssociationSet Name="FolderComments" Association="DocFoldersDbModel.Store.FolderComments">
      <End Role="Folder" EntitySet="Folders" />
      <End Role="Comment" EntitySet="Comments" />
    </AssociationSet>
    <AssociationSet Name="FK_DocAttachments_MainDoc" Association="DocFoldersDbModel.Store.FK_DocAttachments_MainDoc">
      <End Role="MainDoc" EntitySet="Docs" />
      <End Role="DocAttachments" EntitySet="DocAttachments" />
    </AssociationSet>
    <AssociationSet Name="FK_DocAttachments_AttachedDoc" Association="DocFoldersDbModel.Store.FK_DocAttachments_AttachedDoc">
      <End Role="AttachedDoc" EntitySet="Docs" />
      <End Role="DocAttachments" EntitySet="DocAttachments" />
    </AssociationSet>
    <AssociationSet Name="FK_FolderSubFolders_ParentFolder" Association="DocFoldersDbModel.Store.FK_FolderSubFolders_ParentFolder">
      <End Role="ParentFolder" EntitySet="Folders" />
      <End Role="FolderSubFolders" EntitySet="FolderSubFolders" />
    </AssociationSet>
    <AssociationSet Name="FK_FolderSubFolders_SubFolder" Association="DocFoldersDbModel.Store.FK_FolderSubFolders_SubFolder">
      <End Role="SubFolder" EntitySet="Folders" />
      <End Role="FolderSubFolders" EntitySet="FolderSubFolders" />
    </AssociationSet>
  </EntityContainer>
  <EntityType Name="Folders">
    <Key>
      <PropertyRef Name="Id" />
    </Key>
    <Property Name="Id" Type="uniqueidentifier" StoreGeneratedPattern="Identity" Nullable="false" />
    <Property Name="Caption" Type="nvarchar(max)" Nullable="false" />
    <Property Name="Source" Type="nvarchar(max)" Nullable="true" />
  </EntityType>
  <EntityType Name="Docs">
    <Key>
      <PropertyRef Name="Id" />
    </Key>
    <Property Name="Id" Type="uniqueidentifier" StoreGeneratedPattern="Identity" Nullable="false" />
    <Property Name="Caption" Type="nvarchar(max)" Nullable="false" />
    <Property Name="Source" Type="nvarchar(max)" Nullable="true" />
    <Property Name="Title" Type="nvarchar(max)" Nullable="true" />
    <Property Name="Content" Type="nvarchar(max)" Nullable="true" />
    <Property Name="DateLoaded" Type="datetime" Nullable="true" />
    <Property Name="UserLoaded" Type="nvarchar(max)" Nullable="true" />
    <Property Name="DateChanged" Type="datetime" Nullable="true" />
    <Property Name="UserChanged" Type="nvarchar(max)" Nullable="true" />
    <Property Name="DateSigned" Type="datetime" Nullable="true" />
    <Property Name="DateFixed" Type="datetime" Nullable="true" />
    <Property Name="DateExpired" Type="datetime" Nullable="true" />
  </EntityType>
  <EntityType Name="Comments">
    <Key>
      <PropertyRef Name="Id" />
    </Key>
    <Property Name="Id" Type="uniqueidentifier" StoreGeneratedPattern="Identity" Nullable="false" />
    <Property Name="DateCreated" Type="datetime" Nullable="true" />
    <Property Name="UserCreated" Type="nvarchar(max)" Nullable="true" />
    <Property Name="Content" Type="nvarchar(max)" Nullable="false" />
    <Property Name="DocId" Type="uniqueidentifier" Nullable="false" />
    <Property Name="FolderId" Type="uniqueidentifier" Nullable="false" />
  </EntityType>
  <EntityType Name="FolderDocs">
    <Key>
      <PropertyRef Name="Folders_Id" />
      <PropertyRef Name="Docs_Id" />
    </Key>
    <Property Name="Folders_Id" Type="uniqueidentifier" Nullable="false" />
    <Property Name="Docs_Id" Type="uniqueidentifier" Nullable="false" />
  </EntityType>
  <EntityType Name="DocAttachments">
    <Key>
      <PropertyRef Name="AttachedDocs_Id" />
      <PropertyRef Name="MainDocs_Id" />
    </Key>
    <Property Name="AttachedDocs_Id" Type="uniqueidentifier" Nullable="false" />
    <Property Name="MainDocs_Id" Type="uniqueidentifier" Nullable="false" />
  </EntityType>
  <EntityType Name="FolderSubFolders">
    <Key>
      <PropertyRef Name="SubFolders_Id" />
      <PropertyRef Name="ParentFolders_Id" />
    </Key>
    <Property Name="SubFolders_Id" Type="uniqueidentifier" Nullable="false" />
    <Property Name="ParentFolders_Id" Type="uniqueidentifier" Nullable="false" />
  </EntityType>
  <Association Name="DocComments">
    <End Role="Doc" Type="DocFoldersDbModel.Store.Docs" Multiplicity="1" />
    <End Role="Comment" Type="DocFoldersDbModel.Store.Comments" Multiplicity="*" />
    <ReferentialConstraint>
      <Principal Role="Doc">
        <PropertyRef Name="Id" />
      </Principal>
      <Dependent Role="Comment">
        <PropertyRef Name="DocId" />
      </Dependent>
    </ReferentialConstraint>
  </Association>
  <Association Name="FolderComments">
    <End Role="Folder" Type="DocFoldersDbModel.Store.Folders" Multiplicity="1" />
    <End Role="Comment" Type="DocFoldersDbModel.Store.Comments" Multiplicity="*" />
    <ReferentialConstraint>
      <Principal Role="Folder">
        <PropertyRef Name="Id" />
      </Principal>
      <Dependent Role="Comment">
        <PropertyRef Name="FolderId" />
      </Dependent>
    </ReferentialConstraint>
  </Association>
  <Association Name="FK_FolderDocs_Folder">
    <End Role="Folder" Type="DocFoldersDbModel.Store.Folders" Multiplicity="1" />
    <End Role="FolderDocs" Type="DocFoldersDbModel.Store.FolderDocs" Multiplicity="*" />
    <ReferentialConstraint>
      <Principal Role="Folder">
        <PropertyRef Name="Id" />
      </Principal>
      <Dependent Role="FolderDocs">
        <PropertyRef Name="Folders_Id" />
      </Dependent>
    </ReferentialConstraint>
  </Association>
  <Association Name="FK_FolderDocs_Doc">
    <End Role="FolderDocs" Type="DocFoldersDbModel.Store.FolderDocs" Multiplicity="*" />
    <End Role="Doc" Type="DocFoldersDbModel.Store.Docs" Multiplicity="1" />
    <ReferentialConstraint>
      <Principal Role="Doc">
        <PropertyRef Name="Id" />
      </Principal>
      <Dependent Role="FolderDocs">
        <PropertyRef Name="Docs_Id" />
      </Dependent>
    </ReferentialConstraint>
  </Association>
  <Association Name="FK_DocAttachments_MainDoc">
    <End Role="MainDoc" Type="DocFoldersDbModel.Store.Docs" Multiplicity="1" />
    <End Role="DocAttachments" Type="DocFoldersDbModel.Store.DocAttachments" Multiplicity="*" />
    <ReferentialConstraint>
      <Principal Role="MainDoc">
        <PropertyRef Name="Id" />
      </Principal>
      <Dependent Role="DocAttachments">
        <PropertyRef Name="AttachedDocs_Id" />
      </Dependent>
    </ReferentialConstraint>
  </Association>
  <Association Name="FK_DocAttachments_AttachedDoc">
    <End Role="DocAttachments" Type="DocFoldersDbModel.Store.DocAttachments" Multiplicity="*" />
    <End Role="AttachedDoc" Type="DocFoldersDbModel.Store.Docs" Multiplicity="1" />
    <ReferentialConstraint>
      <Principal Role="AttachedDoc">
        <PropertyRef Name="Id" />
      </Principal>
      <Dependent Role="DocAttachments">
        <PropertyRef Name="MainDocs_Id" />
      </Dependent>
    </ReferentialConstraint>
  </Association>
  <Association Name="FK_FolderSubFolders_ParentFolder">
    <End Role="ParentFolder" Type="DocFoldersDbModel.Store.Folders" Multiplicity="1" />
    <End Role="FolderSubFolders" Type="DocFoldersDbModel.Store.FolderSubFolders" Multiplicity="*" />
    <ReferentialConstraint>
      <Principal Role="ParentFolder">
        <PropertyRef Name="Id" />
      </Principal>
      <Dependent Role="FolderSubFolders">
        <PropertyRef Name="SubFolders_Id" />
      </Dependent>
    </ReferentialConstraint>
  </Association>
  <Association Name="FK_FolderSubFolders_SubFolder">
    <End Role="FolderSubFolders" Type="DocFoldersDbModel.Store.FolderSubFolders" Multiplicity="*" />
    <End Role="SubFolder" Type="DocFoldersDbModel.Store.Folders" Multiplicity="1" />
    <ReferentialConstraint>
      <Principal Role="SubFolder">
        <PropertyRef Name="Id" />
      </Principal>
      <Dependent Role="FolderSubFolders">
        <PropertyRef Name="ParentFolders_Id" />
      </Dependent>
    </ReferentialConstraint>
  </Association>
</Schema></edmx:StorageModels>
    <!-- CSDL content -->
    <edmx:ConceptualModels>
      <Schema xmlns="http://schemas.microsoft.com/ado/2009/11/edm" xmlns:cg="http://schemas.microsoft.com/ado/2006/04/codegeneration" xmlns:store="http://schemas.microsoft.com/ado/2007/12/edm/EntityStoreSchemaGenerator" Namespace="DocFoldersDbModel" Alias="Self" xmlns:annotation="http://schemas.microsoft.com/ado/2009/02/edm/annotation" annotation:UseStrongSpatialTypes="false">
        <EntityContainer Name="DocFoldersDbModelContainer" annotation:LazyLoadingEnabled="true">
          <EntitySet Name="Folders" EntityType="DocFoldersDbModel.Folder" />
          <EntitySet Name="Docs" EntityType="DocFoldersDbModel.Doc" />
          <EntitySet Name="Comments" EntityType="DocFoldersDbModel.Comment" />
          <AssociationSet Name="FolderDocs" Association="DocFoldersDbModel.FolderDocs">
            <End Role="Folder" EntitySet="Folders" />
            <End Role="Doc" EntitySet="Docs" />
          </AssociationSet>
          <AssociationSet Name="DocComments" Association="DocFoldersDbModel.DocComments">
            <End Role="Doc" EntitySet="Docs" />
            <End Role="Comment" EntitySet="Comments" />
          </AssociationSet>
          <AssociationSet Name="FolderComments" Association="DocFoldersDbModel.FolderComments">
            <End Role="Folder" EntitySet="Folders" />
            <End Role="Comment" EntitySet="Comments" />
          </AssociationSet>
          <AssociationSet Name="DocAttachments" Association="DocFoldersDbModel.DocAttachments">
            <End Role="MainDoc" EntitySet="Docs" />
            <End Role="AttachedDoc" EntitySet="Docs" />
          </AssociationSet>
          <AssociationSet Name="FolderSubFolders" Association="DocFoldersDbModel.FolderSubFolders">
            <End Role="ParentFolder" EntitySet="Folders" />
            <End Role="SubFolder" EntitySet="Folders" />
          </AssociationSet>
        </EntityContainer>
        <EntityType Name="Folder">
          <Documentation>
            <Summary>Папки</Summary>
            <LongDescription>Таблица папок</LongDescription>
          </Documentation>
          <Key>
            <PropertyRef Name="Id" />
          </Key>
          <Property Name="Id" Type="Guid" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
          <Property Name="Caption" Type="String" Nullable="false" Unicode="true" >
            <Documentation>
              <Summary>Название</Summary>
              <LongDescription>Название папки</LongDescription>
            </Documentation>
          </Property>
          <Property Name="Source" Type="String" Nullable="true" >
            <Documentation>
              <Summary>Папка</Summary>
              <LongDescription>Исходный путь к папке</LongDescription>
            </Documentation>
          </Property>
          <NavigationProperty Name="Docs" Relationship="DocFoldersDbModel.FolderDocs" FromRole="Folder" ToRole="Doc" >
            <Documentation>
              <Summary>Документ</Summary>
              <LongDescription>Вложенный документ</LongDescription>
            </Documentation>
          </NavigationProperty>
          <NavigationProperty Name="Comments" Relationship="DocFoldersDbModel.FolderComments" FromRole="Folder" ToRole="Comment" >
            <Documentation>
              <Summary>Комментарий</Summary>
              <LongDescription>Комментарий к папке</LongDescription>
            </Documentation>
          </NavigationProperty>
          <NavigationProperty Name="ParentFolders" Relationship="DocFoldersDbModel.FolderSubFolders" FromRole="ParentFolder" ToRole="SubFolder" />
          <NavigationProperty Name="SubFolders" Relationship="DocFoldersDbModel.FolderSubFolders" FromRole="SubFolder" ToRole="ParentFolder" />
        </EntityType>
        <EntityType Name="Doc">
          <Documentation>
            <Summary>Документы</Summary>
            <LongDescription>Таблица документов</LongDescription>
          </Documentation>
          <Key>
            <PropertyRef Name="Id" />
          </Key>
          <Property Name="Id" Type="Guid" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
          <Property Name="Caption" Type="String" Nullable="false" Unicode="true" >
            <Documentation>
              <Summary>Название</Summary>
              <LongDescription>Краткое название документа</LongDescription>
            </Documentation>
          </Property>
          <Property Name="Source" Type="String" Nullable="true" >
            <Documentation>
              <Summary>Файл</Summary>
              <LongDescription>Исходный путь к файлу</LongDescription>
            </Documentation>
          </Property>
          <Property Name="Title" Type="String" Nullable="true" Unicode="true" >
            <Documentation>
              <Summary>Полное название</Summary>
              <LongDescription>Полное название документа</LongDescription>
            </Documentation>
          </Property>
          <Property Name="Content" Type="String" Nullable="true" Unicode="true" >
            <Documentation>
              <Summary>Текст</Summary>
              <LongDescription>Содержание документа</LongDescription>
            </Documentation>
          </Property>
          <Property Name="DateLoaded" Type="DateTime" Nullable="true" >
            <Documentation>
              <Summary>Создан</Summary>
              <LongDescription>Дата и время загрузки в систему</LongDescription>
            </Documentation>
          </Property>
          <Property Name="UserLoaded" Type="String" Nullable="true" Unicode="true" >
            <Documentation>
              <Summary>Создал</Summary>
              <LongDescription>Кем создан документ</LongDescription>
            </Documentation>
          </Property>
          <Property Name="DateChanged" Type="DateTime" Nullable="true" >
            <Documentation>
              <Summary>Изменен</Summary>
              <LongDescription>Дата и время изменения документа</LongDescription>
            </Documentation>
          </Property>
          <Property Name="UserChanged" Type="String" Nullable="true" Unicode="true" >
            <Documentation>
              <Summary>Изменил</Summary>
              <LongDescription>Кем изменен документ</LongDescription>
            </Documentation>
          </Property>
          <NavigationProperty Name="Folders" Relationship="DocFoldersDbModel.FolderDocs" FromRole="Doc" ToRole="Folder" >
            <Documentation>
              <Summary>Папка</Summary>
              <LongDescription>Куда вложен документ</LongDescription>
            </Documentation>
          </NavigationProperty>
          <NavigationProperty Name="Comments" Relationship="DocFoldersDbModel.DocComments" FromRole="Doc" ToRole="Comment" >
            <Documentation>
              <Summary>Комментарий</Summary>
              <LongDescription>Комментарий к документу</LongDescription>
            </Documentation>
          </NavigationProperty>
          <NavigationProperty Name="MainDocs" Relationship="DocFoldersDbModel.DocAttachments" FromRole="MainDoc" ToRole="AttachedDoc" >
            <Documentation>
              <Summary>Документ</Summary>
              <LongDescription>Основной документ</LongDescription>
            </Documentation>
          </NavigationProperty>
          <NavigationProperty Name="AttachedDocs" Relationship="DocFoldersDbModel.DocAttachments" FromRole="AttachedDoc" ToRole="MainDoc" >
            <Documentation>
              <Summary>Приложение</Summary>
              <LongDescription>Приложение к документу</LongDescription>
            </Documentation>
          </NavigationProperty>
          <Property Name="DateSigned" Type="DateTime" Nullable="true" >
            <Documentation>
              <Summary>Дата подписания</Summary>
              <LongDescription>Дата подписания документа</LongDescription>
            </Documentation>
          </Property>
          <Property Name="DateFixed" Type="DateTime" Nullable="true" >
            <Documentation>
              <Summary>Дата фиксации</Summary>
              <LongDescription>Дата фиксации состояния документа</LongDescription>
            </Documentation>
          </Property>
          <Property Name="DateExpired" Type="DateTime" Nullable="true">
            <Documentation>
              <Summary>Годен до</Summary>
              <LongDescription>Дата истечения срока действия</LongDescription>
            </Documentation>
          </Property>
        </EntityType>
        <EntityType Name="Comment">
          <Documentation>
            <Summary>Комментарии</Summary>
            <LongDescription>Таблица комментариев</LongDescription>
          </Documentation>
          <Key>
            <PropertyRef Name="Id" />
          </Key>
          <Property Name="Id" Type="Guid" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
          <Property Name="DateCreated" Type="DateTime" Nullable="true" >
            <Documentation>
              <Summary>Создан</Summary>
              <LongDescription>Дата и время создания комментария</LongDescription>
            </Documentation>
          </Property>
          <Property Name="UserCreated" Type="String" Nullable="true" Unicode="true" >
            <Documentation>
              <Summary>Создал</Summary>
              <LongDescription>Кем создан комментарий</LongDescription>
            </Documentation>
          </Property>
          <Property Name="Content" Type="String" Nullable="false" Unicode="true" >
            <Documentation>
              <Summary>Текст</Summary>
              <LongDescription>Содержание комментария</LongDescription>
            </Documentation>
          </Property>
          <NavigationProperty Name="Doc" Relationship="DocFoldersDbModel.DocComments" FromRole="Comment" ToRole="Doc" >
            <Documentation>
              <Summary>Документ</Summary>
              <LongDescription>Комментируемый документ</LongDescription>
            </Documentation>
          </NavigationProperty>
          <Property Name="DocId" Type="Guid" Nullable="false" />
          <NavigationProperty Name="Folder" Relationship="DocFoldersDbModel.FolderComments" FromRole="Comment" ToRole="Folder" >
            <Documentation>
              <Summary>Папка</Summary>
              <LongDescription>Комментируемая папка</LongDescription>
            </Documentation>
          </NavigationProperty>
          <Property Name="FolderId" Type="Guid" Nullable="false" />
        </EntityType>
        <Association Name="FolderDocs">
          <Documentation>
            <Summary>Папка с документами</Summary>
            <LongDescription>Папка с вложенными документами</LongDescription>
          </Documentation>
          <End Type="DocFoldersDbModel.Folder" Role="Folder" Multiplicity="*" >
          </End>
          <End Type="DocFoldersDbModel.Doc" Role="Doc" Multiplicity="*" />
        </Association>
        <Association Name="DocComments">
          <Documentation>
            <Summary>Комментарии</Summary>
            <LongDescription>Комментарии к документу</LongDescription>
          </Documentation>
          <End Type="DocFoldersDbModel.Doc" Role="Doc" Multiplicity="1" />
          <End Type="DocFoldersDbModel.Comment" Role="Comment" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="Doc">
              <PropertyRef Name="Id" />
            </Principal>
            <Dependent Role="Comment">
              <PropertyRef Name="DocId" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <Association Name="FolderComments">
          <Documentation>
            <Summary>Комментарии</Summary>
            <LongDescription>Комментарии к папке</LongDescription>
          </Documentation>
          <End Type="DocFoldersDbModel.Folder" Role="Folder" Multiplicity="1" />
          <End Type="DocFoldersDbModel.Comment" Role="Comment" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="Folder">
              <PropertyRef Name="Id" />
            </Principal>
            <Dependent Role="Comment">
              <PropertyRef Name="FolderId" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <Association Name="DocAttachments">
          <Documentation>
            <Summary>Приложения</Summary>
            <LongDescription>Основной документ с приложениями</LongDescription>
          </Documentation>
          <End Type="DocFoldersDbModel.Doc" Role="MainDoc" Multiplicity="*" />
          <End Type="DocFoldersDbModel.Doc" Role="AttachedDoc" Multiplicity="*" />
        </Association>
        <Association Name="FolderSubFolders">
          <Documentation>
            <Summary>Папка с папками</Summary>
            <LongDescription>Папка с вложенными подпапками</LongDescription>
          </Documentation>
          <End Type="DocFoldersDbModel.Folder" Role="ParentFolder" Multiplicity="*" />
          <End Type="DocFoldersDbModel.Folder" Role="SubFolder" Multiplicity="*" />
        </Association>
      </Schema>
    </edmx:ConceptualModels>
    <!-- C-S mapping content -->
    <edmx:Mappings>
    <Mapping Space="C-S" xmlns="http://schemas.microsoft.com/ado/2009/11/mapping/cs">
  <EntityContainerMapping StorageEntityContainer="DocFoldersDbModelStoreContainer" CdmEntityContainer="DocFoldersDbModelContainer">
    <EntitySetMapping Name="Folders">
      <EntityTypeMapping TypeName="IsTypeOf(DocFoldersDbModel.Folder)">
        <MappingFragment StoreEntitySet="Folders">
          <ScalarProperty Name="Id" ColumnName="Id" />
          <ScalarProperty Name="Caption" ColumnName="Caption" />
          <ScalarProperty Name="Source" ColumnName="Source" />
        </MappingFragment>
      </EntityTypeMapping>
    </EntitySetMapping>
    <EntitySetMapping Name="Docs">
      <EntityTypeMapping TypeName="IsTypeOf(DocFoldersDbModel.Doc)">
        <MappingFragment StoreEntitySet="Docs">
          <ScalarProperty Name="Id" ColumnName="Id" />
          <ScalarProperty Name="Caption" ColumnName="Caption" />
          <ScalarProperty Name="Source" ColumnName="Source" />
          <ScalarProperty Name="Title" ColumnName="Title" />
          <ScalarProperty Name="Content" ColumnName="Content" />
          <ScalarProperty Name="DateLoaded" ColumnName="DateLoaded" />
          <ScalarProperty Name="UserLoaded" ColumnName="UserLoaded" />
          <ScalarProperty Name="DateChanged" ColumnName="DateChanged" />
          <ScalarProperty Name="UserChanged" ColumnName="UserChanged" />
          <ScalarProperty Name="DateSigned" ColumnName="DateSigned" />
          <ScalarProperty Name="DateFixed" ColumnName="DateFixed" />
          <ScalarProperty Name="DateExpired" ColumnName="DateExpired" />
        </MappingFragment>
      </EntityTypeMapping>
    </EntitySetMapping>
    <EntitySetMapping Name="Comments">
      <EntityTypeMapping TypeName="IsTypeOf(DocFoldersDbModel.Comment)">
        <MappingFragment StoreEntitySet="Comments">
          <ScalarProperty Name="Id" ColumnName="Id" />
          <ScalarProperty Name="DateCreated" ColumnName="DateCreated" />
          <ScalarProperty Name="UserCreated" ColumnName="UserCreated" />
          <ScalarProperty Name="Content" ColumnName="Content" />
          <ScalarProperty Name="DocId" ColumnName="DocId" />
          <ScalarProperty Name="FolderId" ColumnName="FolderId" />
        </MappingFragment>
      </EntityTypeMapping>
    </EntitySetMapping>
    <AssociationSetMapping Name="FolderDocs" TypeName="DocFoldersDbModel.FolderDocs" StoreEntitySet="FolderDocs">
      <EndProperty Name="Folder">
        <ScalarProperty Name="Id" ColumnName="Folders_Id" />
      </EndProperty>
      <EndProperty Name="Doc">
        <ScalarProperty Name="Id" ColumnName="Docs_Id" />
      </EndProperty>
    </AssociationSetMapping>
    <AssociationSetMapping Name="DocAttachments" TypeName="DocFoldersDbModel.DocAttachments" StoreEntitySet="DocAttachments">
      <EndProperty Name="MainDoc">
        <ScalarProperty Name="Id" ColumnName="AttachedDocs_Id" />
      </EndProperty>
      <EndProperty Name="AttachedDoc">
        <ScalarProperty Name="Id" ColumnName="MainDocs_Id" />
      </EndProperty>
    </AssociationSetMapping>
    <AssociationSetMapping Name="FolderSubFolders" TypeName="DocFoldersDbModel.FolderSubFolders" StoreEntitySet="FolderSubFolders">
      <EndProperty Name="ParentFolder">
        <ScalarProperty Name="Id" ColumnName="SubFolders_Id" />
      </EndProperty>
      <EndProperty Name="SubFolder">
        <ScalarProperty Name="Id" ColumnName="ParentFolders_Id" />
      </EndProperty>
    </AssociationSetMapping>
  </EntityContainerMapping>
</Mapping></edmx:Mappings>
  </edmx:Runtime>
  <!-- EF Designer content (DO NOT EDIT MANUALLY BELOW HERE) -->
  <edmx:Designer xmlns="http://schemas.microsoft.com/ado/2009/11/edmx">
    <edmx:Connection>
      <DesignerInfoPropertySet>
        <DesignerProperty Name="MetadataArtifactProcessing" Value="EmbedInOutputAssembly" />
      </DesignerInfoPropertySet>
    </edmx:Connection>
    <edmx:Options>
      <DesignerInfoPropertySet>
        <DesignerProperty Name="ValidateOnBuild" Value="true" />
        <DesignerProperty Name="EnablePluralization" Value="False" />
        <DesignerProperty Name="CodeGenerationStrategy" Value="Нет" />
        <DesignerProperty Name="UseLegacyProvider" Value="False" />
      </DesignerInfoPropertySet>
    </edmx:Options>
    <!-- Diagram content (shape and connector positions) -->
    <edmx:Diagrams>
    </edmx:Diagrams>
  </edmx:Designer>
</edmx:Edmx>
